Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	33045
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	64
Duplicate rows (%)	0.2%
Total size in memory	3.0 MiB
Average record size in memory	96.0 B

Variable types

Categorical	9
Numeric	3

Alerts

Dataset has 64 (0.2%) duplicate rows	Duplicates
`Date` has a high cardinality: 1697 distinct values	High cardinality
`Products` has a high cardinality: 105 distinct values	High cardinality
`Quantity` is highly overall correlated with `Value`	High correlation
`Rate` is highly overall correlated with `FY` and 1 other fields	High correlation
`Value` is highly overall correlated with `Quantity`	High correlation
`FY` is highly overall correlated with `Rate` and 1 other fields	High correlation
`dia` is highly overall correlated with `dia group`	High correlation
`dia group` is highly overall correlated with `dia`	High correlation
`grade` is highly overall correlated with `Rate` and 1 other fields	High correlation
`type` is highly overall correlated with `length`	High correlation
`length` is highly overall correlated with `type`	High correlation
`type` is highly imbalanced (77.2%)	Imbalance
`length` is highly imbalanced (82.4%)	Imbalance
`Voucher Type` is highly imbalanced (85.4%)	Imbalance

Reproduction

Analysis started	2023-08-13 14:07:51.392828
Analysis finished	2023-08-13 14:08:11.408152
Duration	20.02 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Date
Categorical

Distinct	1697
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

01-09-2020	62
12/30/2021	62
01-10-2019	59
8/30/2019	58
8/30/2018	56
Other values (1692)	32748

Length

Max length	10
Median length	10
Mean length	9.5063701
Min length	9

Characters and Unicode

Total characters	314138
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	04-03-2017
2nd row	04-03-2017
3rd row	04-03-2017
4th row	04-03-2017
5th row	04-03-2017

Common Values

Value	Count	Frequency (%)
01-09-2020	62	0.2%
12/30/2021	62	0.2%
01-10-2019	59	0.2%
8/30/2019	58	0.2%
8/30/2018	56	0.2%
3/15/2019	55	0.2%
3/31/2019	55	0.2%
7/13/2019	54	0.2%
12-09-2019	54	0.2%
7/30/2019	53	0.2%
Other values (1687)	32477	98.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
01-09-2020	62	0.2%
12/30/2021	62	0.2%
01-10-2019	59	0.2%
8/30/2019	58	0.2%
8/30/2018	56	0.2%
3/15/2019	55	0.2%
3/31/2019	55	0.2%
7/13/2019	54	0.2%
12-09-2019	54	0.2%
7/30/2019	53	0.2%
Other values (1687)	32477	98.3%

Most occurring characters

Value	Count	Frequency (%)
2	75436	24.0%
0	61046	19.4%
1	50261	16.0%
/	43182	13.7%
-	22908	7.3%
9	13123	4.2%
8	12418	4.0%
7	10368	3.3%
3	8965	2.9%
6	5748	1.8%
Other values (2)	10683	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	248048	79.0%
Other Punctuation	43182	13.7%
Dash Punctuation	22908	7.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	75436	30.4%
0	61046	24.6%
1	50261	20.3%
9	13123	5.3%
8	12418	5.0%
7	10368	4.2%
3	8965	3.6%
6	5748	2.3%
5	5590	2.3%
4	5093	2.1%

Other Punctuation

Value	Count	Frequency (%)
/	43182	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	22908	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	314138	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	75436	24.0%
0	61046	19.4%
1	50261	16.0%
/	43182	13.7%
-	22908	7.3%
9	13123	4.2%
8	12418	4.0%
7	10368	3.3%
3	8965	2.9%
6	5748	1.8%
Other values (2)	10683	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	314138	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	75436	24.0%
0	61046	19.4%
1	50261	16.0%
/	43182	13.7%
-	22908	7.3%
9	13123	4.2%
8	12418	4.0%
7	10368	3.3%
3	8965	2.9%
6	5748	1.8%
Other values (2)	10683	3.4%

FY
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

FY 20	6402
FY 19	6251
FY 22	5633
FY 18	5157
FY 23	4876

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	165225
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FY 18
2nd row	FY 18
3rd row	FY 18
4th row	FY 18
5th row	FY 18

Common Values

Value	Count	Frequency (%)
FY 20	6402	19.4%
FY 19	6251	18.9%
FY 22	5633	17.0%
FY 18	5157	15.6%
FY 23	4876	14.8%
FY 21	4726	14.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fy	33045	50.0%
20	6402	9.7%
19	6251	9.5%
22	5633	8.5%
18	5157	7.8%
23	4876	7.4%
21	4726	7.2%

Most occurring characters

Value	Count	Frequency (%)
F	33045	20.0%
Y	33045	20.0%
	33045	20.0%
2	27270	16.5%
1	16134	9.8%
0	6402	3.9%
9	6251	3.8%
8	5157	3.1%
3	4876	3.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	66090	40.0%
Decimal Number	66090	40.0%
Space Separator	33045	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	27270	41.3%
1	16134	24.4%
0	6402	9.7%
9	6251	9.5%
8	5157	7.8%
3	4876	7.4%

Uppercase Letter

Value	Count	Frequency (%)
F	33045	50.0%
Y	33045	50.0%

Space Separator

Value	Count	Frequency (%)
	33045	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99135	60.0%
Latin	66090	40.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	33045	33.3%
2	27270	27.5%
1	16134	16.3%
0	6402	6.5%
9	6251	6.3%
8	5157	5.2%
3	4876	4.9%

Latin

Value	Count	Frequency (%)
F	33045	50.0%
Y	33045	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	165225	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	33045	20.0%
Y	33045	20.0%
	33045	20.0%
2	27270	16.5%
1	16134	9.8%
0	6402	3.9%
9	6251	3.8%
8	5157	3.1%
3	4876	3.0%

Products
Categorical

Distinct	105
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

08MM TATA TISCON FE500D (S)	3866
16MM TATA TISCON FE500D (S)	3532
12MM TATA TISCON FE500D (S)	3486
10MM TATA TISCON FE500D (S)	3088
16MM TATA TISCON FE500D (T)	1837
Other values (100)	17236

Length

Max length	44
Median length	27
Mean length	27.865154
Min length	9

Characters and Unicode

Total characters	920804
Distinct characters	35
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13 ?
Unique (%)	< 0.1%

Sample

1st row	25MM TATA TISCON FE500D (S)
2nd row	08MM TATA TISCON FE500D (S)
3rd row	10MM TATA TISCON FE500D (S)
4th row	12MM TATA TISCON FE500D (S)
5th row	16MM TATA TISCON FE500D (S)

Common Values

Value	Count	Frequency (%)
08MM TATA TISCON FE500D (S)	3866	11.7%
16MM TATA TISCON FE500D (S)	3532	10.7%
12MM TATA TISCON FE500D (S)	3486	10.5%
10MM TATA TISCON FE500D (S)	3088	9.3%
16MM TATA TISCON FE500D (T)	1837	5.6%
20MM TATA TISCON FE500D (S)	1774	5.4%
08MM TATA TISCON FE500D (T)	1748	5.3%
10MM TATA TISCON FE500D (T)	1664	5.0%
12MM TATA TISCON FE500D (T)	1571	4.8%
20MM TATA TISCON FE500D (T)	1285	3.9%
Other values (95)	9194	27.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tiscon	31860	18.9%
tata	31727	18.8%
fe500d	27367	16.2%
s	17522	10.4%
t	14224	8.4%
08mm	6898	4.1%
16mm	6483	3.8%
12mm	6284	3.7%
10mm	5634	3.3%
fe550d	4577	2.7%
Other values (53)	16012	9.5%

Most occurring characters

Value	Count	Frequency (%)
	136210	14.8%
T	115582	12.6%
0	78305	8.5%
M	66146	7.2%
A	63456	6.9%
S	54759	5.9%
5	39580	4.3%
I	36184	3.9%
C	35277	3.8%
O	34908	3.8%
Other values (25)	260397	28.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	542799	58.9%
Decimal Number	170544	18.5%
Space Separator	136210	14.8%
Close Punctuation	32726	3.6%
Open Punctuation	32726	3.6%
Lowercase Letter	3057	0.3%
Dash Punctuation	1499	0.2%
Other Punctuation	1243	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	115582	21.3%
M	66146	12.2%
A	63456	11.7%
S	54759	10.1%
I	36184	6.7%
C	35277	6.5%
O	34908	6.4%
E	33999	6.3%
D	33913	6.2%
N	33003	6.1%
Other values (6)	35572	6.6%

Decimal Number

Value	Count	Frequency (%)
0	78305	45.9%
5	39580	23.2%
1	20750	12.2%
2	12862	7.5%
8	8868	5.2%
6	8015	4.7%
7	1545	0.9%
3	527	0.3%
4	92	0.1%

Close Punctuation

Value	Count	Frequency (%)
)	32721	> 99.9%
]	5	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	32721	> 99.9%
[	5	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
m	2763	90.4%
e	294	9.6%

Other Punctuation

Value	Count	Frequency (%)
:	1232	99.1%
.	11	0.9%

Space Separator

Value	Count	Frequency (%)
	136210	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1499	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	545856	59.3%
Common	374948	40.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	115582	21.2%
M	66146	12.1%
A	63456	11.6%
S	54759	10.0%
I	36184	6.6%
C	35277	6.5%
O	34908	6.4%
E	33999	6.2%
D	33913	6.2%
N	33003	6.0%
Other values (8)	38629	7.1%

Common

Value	Count	Frequency (%)
	136210	36.3%
0	78305	20.9%
5	39580	10.6%
)	32721	8.7%
(	32721	8.7%
1	20750	5.5%
2	12862	3.4%
8	8868	2.4%
6	8015	2.1%
7	1545	0.4%
Other values (7)	3371	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	920804	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	136210	14.8%
T	115582	12.6%
0	78305	8.5%
M	66146	7.2%
A	63456	6.9%
S	54759	5.9%
5	39580	4.3%
I	36184	3.9%
C	35277	3.8%
O	34908	3.8%
Other values (25)	260397	28.3%

dia
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

08 MM	7508
16 MM	6735
12 MM	6575
10 MM	5953
20 MM	3695
Other values (5)	2579

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	165225
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	25 MM
2nd row	08 MM
3rd row	10 MM
4th row	12 MM
5th row	16 MM

Common Values

Value	Count	Frequency (%)
08 MM	7508	22.7%
16 MM	6735	20.4%
12 MM	6575	19.9%
10 MM	5953	18.0%
20 MM	3695	11.2%
25 MM	1979	6.0%
32 MM	525	1.6%
28 MM	71	0.2%
06 MM	2	< 0.1%
36 MM	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mm	33045	50.0%
08	7508	11.4%
16	6735	10.2%
12	6575	9.9%
10	5953	9.0%
20	3695	5.6%
25	1979	3.0%
32	525	0.8%
28	71	0.1%
06	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	66090	40.0%
	33045	20.0%
1	19263	11.7%
0	17158	10.4%
2	12845	7.8%
8	7579	4.6%
6	6739	4.1%
5	1979	1.2%
3	527	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	66090	40.0%
Decimal Number	66090	40.0%
Space Separator	33045	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	19263	29.1%
0	17158	26.0%
2	12845	19.4%
8	7579	11.5%
6	6739	10.2%
5	1979	3.0%
3	527	0.8%

Uppercase Letter

Value	Count	Frequency (%)
M	66090	100.0%

Space Separator

Value	Count	Frequency (%)
	33045	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99135	60.0%
Latin	66090	40.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	33045	33.3%
1	19263	19.4%
0	17158	17.3%
2	12845	13.0%
8	7579	7.6%
6	6739	6.8%
5	1979	2.0%
3	527	0.5%

Latin

Value	Count	Frequency (%)
M	66090	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	165225	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	66090	40.0%
	33045	20.0%
1	19263	11.7%
0	17158	10.4%
2	12845	7.8%
8	7579	4.6%
6	6739	4.1%
5	1979	1.2%
3	527	0.3%

dia group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

12 MM - 32 MM	19542
08 MM	7508
10 MM	5953
28 MM	40
06 MM	2

Length

Max length	13
Median length	13
Mean length	9.7310032
Min length	5

Characters and Unicode

Total characters	321561
Distinct characters	9
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	12 MM - 32 MM
2nd row	08 MM
3rd row	10 MM
4th row	12 MM - 32 MM
5th row	12 MM - 32 MM

Common Values

Value	Count	Frequency (%)
12 MM - 32 MM	19542	59.1%
08 MM	7508	22.7%
10 MM	5953	18.0%
28 MM	40	0.1%
06 MM	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mm	52587	42.2%
12	19542	15.7%
	19542	15.7%
32	19542	15.7%
08	7508	6.0%
10	5953	4.8%
28	40	< 0.1%
06	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
M	105174	32.7%
	91671	28.5%
2	39124	12.2%
1	25495	7.9%
-	19542	6.1%
3	19542	6.1%
0	13463	4.2%
8	7548	2.3%
6	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	105174	32.7%
Decimal Number	105174	32.7%
Space Separator	91671	28.5%
Dash Punctuation	19542	6.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	39124	37.2%
1	25495	24.2%
3	19542	18.6%
0	13463	12.8%
8	7548	7.2%
6	2	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
M	105174	100.0%

Space Separator

Value	Count	Frequency (%)
	91671	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	19542	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	216387	67.3%
Latin	105174	32.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
	91671	42.4%
2	39124	18.1%
1	25495	11.8%
-	19542	9.0%
3	19542	9.0%
0	13463	6.2%
8	7548	3.5%
6	2	< 0.1%

Latin

Value	Count	Frequency (%)
M	105174	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	321561	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	105174	32.7%
	91671	28.5%
2	39124	12.2%
1	25495	7.9%
-	19542	6.1%
3	19542	6.1%
0	13463	4.2%
8	7548	2.3%
6	2	< 0.1%

grade
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

500D	28460
550D	4585

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	132180
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	500D
2nd row	500D
3rd row	500D
4th row	500D
5th row	500D

Common Values

Value	Count	Frequency (%)
500D	28460	86.1%
550D	4585	13.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
500d	28460	86.1%
550d	4585	13.9%

Most occurring characters

Value	Count	Frequency (%)
0	61505	46.5%
5	37630	28.5%
D	33045	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99135	75.0%
Uppercase Letter	33045	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	61505	62.0%
5	37630	38.0%

Uppercase Letter

Value	Count	Frequency (%)
D	33045	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99135	75.0%
Latin	33045	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	61505	62.0%
5	37630	38.0%

Latin

Value	Count	Frequency (%)
D	33045	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	132180	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	61505	46.5%
5	37630	28.5%
D	33045	25.0%

type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

FULL LENGTH	30477
CAB	1290
COIL	615
CRSD	369
SHORT LENGTH	294

Length

Max length	12
Median length	11
Mean length	10.488153
Min length	3

Characters and Unicode

Total characters	346581
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FULL LENGTH
2nd row	FULL LENGTH
3rd row	FULL LENGTH
4th row	FULL LENGTH
5th row	FULL LENGTH

Common Values

Value	Count	Frequency (%)
FULL LENGTH	30477	92.2%
CAB	1290	3.9%
COIL	615	1.9%
CRSD	369	1.1%
SHORT LENGTH	294	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
length	30771	48.2%
full	30477	47.8%
cab	1290	2.0%
coil	615	1.0%
crsd	369	0.6%
short	294	0.5%

Most occurring characters

Value	Count	Frequency (%)
L	92340	26.6%
H	31065	9.0%
T	31065	9.0%
	30771	8.9%
E	30771	8.9%
N	30771	8.9%
G	30771	8.9%
U	30477	8.8%
F	30477	8.8%
C	2274	0.7%
Other values (7)	5799	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	315810	91.1%
Space Separator	30771	8.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	92340	29.2%
H	31065	9.8%
T	31065	9.8%
E	30771	9.7%
N	30771	9.7%
G	30771	9.7%
U	30477	9.7%
F	30477	9.7%
C	2274	0.7%
A	1290	0.4%
Other values (6)	4509	1.4%

Space Separator

Value	Count	Frequency (%)
	30771	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	315810	91.1%
Common	30771	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	92340	29.2%
H	31065	9.8%
T	31065	9.8%
E	30771	9.7%
N	30771	9.7%
G	30771	9.7%
U	30477	9.7%
F	30477	9.7%
C	2274	0.7%
A	1290	0.4%
Other values (6)	4509	1.4%

Common

Value	Count	Frequency (%)
	30771	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	346581	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	92340	26.6%
H	31065	9.0%
T	31065	9.0%
	30771	8.9%
E	30771	8.9%
N	30771	8.9%
G	30771	8.9%
U	30477	8.8%
F	30477	8.8%
C	2274	0.7%
Other values (7)	5799	1.7%

length
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

12 METER	30846
CUSTOMISED	1290
0 METER	615
7 - 10 METER	177
4 - 7 METER	92

Length

Max length	13
Median length	8
Mean length	8.0930247
Min length	7

Characters and Unicode

Total characters	267434
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	12 METER
2nd row	12 METER
3rd row	12 METER
4th row	12 METER
5th row	12 METER

Common Values

Value	Count	Frequency (%)
12 METER	30846	93.3%
CUSTOMISED	1290	3.9%
0 METER	615	1.9%
7 - 10 METER	177	0.5%
4 - 7 METER	92	0.3%
10 - 12 METER	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
meter	31755	48.6%
12	30871	47.2%
customised	1290	2.0%
0	615	0.9%
	294	0.4%
7	269	0.4%
10	202	0.3%
4	92	0.1%

Most occurring characters

Value	Count	Frequency (%)
E	64800	24.2%
M	33045	12.4%
T	33045	12.4%
	32343	12.1%
R	31755	11.9%
1	31073	11.6%
2	30871	11.5%
S	2580	1.0%
I	1290	0.5%
D	1290	0.5%
Other values (7)	5342	2.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	171675	64.2%
Decimal Number	63122	23.6%
Space Separator	32343	12.1%
Dash Punctuation	294	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	64800	37.7%
M	33045	19.2%
T	33045	19.2%
R	31755	18.5%
S	2580	1.5%
I	1290	0.8%
D	1290	0.8%
U	1290	0.8%
O	1290	0.8%
C	1290	0.8%

Decimal Number

Value	Count	Frequency (%)
1	31073	49.2%
2	30871	48.9%
0	817	1.3%
7	269	0.4%
4	92	0.1%

Space Separator

Value	Count	Frequency (%)
	32343	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	294	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	171675	64.2%
Common	95759	35.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	64800	37.7%
M	33045	19.2%
T	33045	19.2%
R	31755	18.5%
S	2580	1.5%
I	1290	0.8%
D	1290	0.8%
U	1290	0.8%
O	1290	0.8%
C	1290	0.8%

Common

Value	Count	Frequency (%)
	32343	33.8%
1	31073	32.4%
2	30871	32.2%
0	817	0.9%
-	294	0.3%
7	269	0.3%
4	92	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	267434	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	64800	24.2%
M	33045	12.4%
T	33045	12.4%
	32343	12.1%
R	31755	11.9%
1	31073	11.6%
2	30871	11.5%
S	2580	1.0%
I	1290	0.5%
D	1290	0.5%
Other values (7)	5342	2.0%

Voucher Type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	258.3 KiB

Sales A/c GST	31578
Sales	1286
Sales(Customised)	99
Credit Note	82

Length

Max length	17
Median length	13
Mean length	12.695688
Min length	5

Characters and Unicode

Total characters	419529
Distinct characters	22
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sales
2nd row	Sales
3rd row	Sales
4th row	Sales
5th row	Sales

Common Values

Value	Count	Frequency (%)
Sales A/c GST	31578	95.6%
Sales	1286	3.9%
Sales(Customised)	99	0.3%
Credit Note	82	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sales	32864	34.1%
a/c	31578	32.8%
gst	31578	32.8%
sales(customised	99	0.1%
credit	82	0.1%
note	82	0.1%

Most occurring characters

Value	Count	Frequency (%)
S	64541	15.4%
	63238	15.1%
e	33226	7.9%
s	33161	7.9%
l	32963	7.9%
a	32963	7.9%
G	31578	7.5%
T	31578	7.5%
c	31578	7.5%
/	31578	7.5%
Other values (12)	33125	7.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	164977	39.3%
Uppercase Letter	159538	38.0%
Space Separator	63238	15.1%
Other Punctuation	31578	7.5%
Close Punctuation	99	< 0.1%
Open Punctuation	99	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	33226	20.1%
s	33161	20.1%
l	32963	20.0%
a	32963	20.0%
c	31578	19.1%
t	263	0.2%
i	181	0.1%
o	181	0.1%
d	181	0.1%
m	99	0.1%
Other values (2)	181	0.1%

Uppercase Letter

Value	Count	Frequency (%)
S	64541	40.5%
G	31578	19.8%
T	31578	19.8%
A	31578	19.8%
C	181	0.1%
N	82	0.1%

Space Separator

Value	Count	Frequency (%)
	63238	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	31578	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	99	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	99	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	324515	77.4%
Common	95014	22.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	64541	19.9%
e	33226	10.2%
s	33161	10.2%
l	32963	10.2%
a	32963	10.2%
G	31578	9.7%
T	31578	9.7%
c	31578	9.7%
A	31578	9.7%
t	263	0.1%
Other values (8)	1086	0.3%

Common

Value	Count	Frequency (%)
	63238	66.6%
/	31578	33.2%
)	99	0.1%
(	99	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	419529	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	64541	15.4%
	63238	15.1%
e	33226	7.9%
s	33161	7.9%
l	32963	7.9%
a	32963	7.9%
G	31578	7.5%
T	31578	7.5%
c	31578	7.5%
/	31578	7.5%
Other values (12)	33125	7.9%

Quantity
Real number (ℝ)

Distinct	3751
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9213287

Minimum	-32.34
Maximum	41.68
Zeros	0
Zeros (%)	0.0%
Negative	81
Negative (%)	0.2%
Memory size	258.3 KiB

Quantile statistics

Minimum	-32.34
5-th percentile	0.5
Q1	1.99
median	3.9
Q3	7.01
95-th percentile	23.358
Maximum	41.68
Range	74.02
Interquartile range (IQR)	5.02

Descriptive statistics

Standard deviation	6.6687238
Coefficient of variation (CV)	1.1262208
Kurtosis	5.0029735
Mean	5.9213287
Median Absolute Deviation (MAD)	2.145
Skewness	2.202827
Sum	195670.31
Variance	44.471877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	360	1.1%
2.02	353	1.1%
2.01	327	1.0%
1	320	1.0%
1.01	297	0.9%
1.99	261	0.8%
2.03	255	0.8%
3	241	0.7%
3.01	206	0.6%
1.05	186	0.6%
Other values (3741)	30239	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-32.34	1	< 0.1%
-25.57	1	< 0.1%
-21.76	1	< 0.1%
-20.04	1	< 0.1%
-18.65	1	< 0.1%
-18.2	1	< 0.1%
-17.77	1	< 0.1%
-16.45	1	< 0.1%
-16.07	1	< 0.1%
-15.3	1	< 0.1%

Value	Count	Frequency (%)
41.68	1	< 0.1%
41.46	1	< 0.1%
39.388	1	< 0.1%
39.38	1	< 0.1%
39.06	1	< 0.1%
39.03	1	< 0.1%
35.26	1	< 0.1%
35.03	1	< 0.1%
34.73	1	< 0.1%
34.646	1	< 0.1%

Rate
Real number (ℝ)

Distinct	1127
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48518.211

Minimum	19590
Maximum	83000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	258.3 KiB

Quantile statistics

Minimum	19590
5-th percentile	36000
Q1	41750
median	45700
Q3	56000
95-th percentile	65000
Maximum	83000
Range	63410
Interquartile range (IQR)	14250

Descriptive statistics

Standard deviation	9640.5077
Coefficient of variation (CV)	0.19869875
Kurtosis	-0.080464253
Mean	48518.211
Median Absolute Deviation (MAD)	6200
Skewness	0.70465357
Sum	1.6032843 × 10⁹
Variance	92939389
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44000	961	2.9%
43000	845	2.6%
43500	732	2.2%
42500	678	2.1%
46000	677	2.0%
42000	668	2.0%
48000	647	2.0%
44500	638	1.9%
45000	580	1.8%
45500	543	1.6%
Other values (1117)	26076	78.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19590	3	< 0.1%
21500	9	< 0.1%
21542	3	< 0.1%
21590	1	< 0.1%
22500	3	< 0.1%
30200	1	< 0.1%
30250	1	< 0.1%
30600	2	< 0.1%
30900	3	< 0.1%
31000	1	< 0.1%

Value	Count	Frequency (%)
83000	1	< 0.1%
82500	3	< 0.1%
82000	2	< 0.1%
81500	3	< 0.1%
81100	1	< 0.1%
81000	3	< 0.1%
80500	14	< 0.1%
80460	1	< 0.1%
80352.54	1	< 0.1%
80000	16	< 0.1%

Value
Real number (ℝ)

Distinct	23853
Distinct (%)	72.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	283942.72

Minimum	-2126355
Maximum	2611980
Zeros	0
Zeros (%)	0.0%
Negative	82
Negative (%)	0.2%
Memory size	258.3 KiB

Quantile statistics

Minimum	-2126355
5-th percentile	24243.6
Q1	88140
median	180147
Q3	325500
95-th percentile	1018026
Maximum	2611980
Range	4738335
Interquartile range (IQR)	237360

Descriptive statistics

Standard deviation	331266.04
Coefficient of variation (CV)	1.1666651
Kurtosis	8.1789313
Mean	283942.72
Median Absolute Deviation (MAD)	106392
Skewness	2.5803349
Sum	9.382887 × 10⁹
Variance	1.0973719 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126000	22	0.1%
42000	15	< 0.1%
85570	15	< 0.1%
63000	14	< 0.1%
86860	14	< 0.1%
84840	14	< 0.1%
52400	14	< 0.1%
45000	13	< 0.1%
85850	12	< 0.1%
87000	12	< 0.1%
Other values (23843)	32900	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2126355	1	< 0.1%
-1305600	1	< 0.1%
-1182360	1	< 0.1%
-1115978.87	1	< 0.1%
-823500	1	< 0.1%
-819570	1	< 0.1%
-780300	1	< 0.1%
-757120	1	< 0.1%
-719687.5	1	< 0.1%
-653458.75	1	< 0.1%

Value	Count	Frequency (%)
2611980	1	< 0.1%
2603604.5	1	< 0.1%
2587200	1	< 0.1%
2553115	1	< 0.1%
2510820	1	< 0.1%
2488682.5	1	< 0.1%
2430890	1	< 0.1%
2426562.5	1	< 0.1%
2422270.24	1	< 0.1%
2373592.5	1	< 0.1%

Auto

Heatmap
Table

	Quantity	Rate	Value	FY	dia	dia group	grade	type	length	Voucher Type
Quantity	1.000	-0.077	0.978	0.055	0.071	0.059	0.021	0.206	0.064	0.410
Rate	-0.077	1.000	0.105	0.538	0.065	0.093	0.501	0.183	0.156	0.165
Value	0.978	0.105	1.000	0.095	0.079	0.070	0.096	0.247	0.049	0.327
FY	0.055	0.538	0.095	1.000	0.035	0.030	0.507	0.141	0.113	0.281
dia	0.071	0.065	0.079	0.035	1.000	0.944	0.063	0.081	0.069	0.005
dia group	0.059	0.093	0.070	0.030	0.944	1.000	0.021	0.065	0.066	0.010
grade	0.021	0.501	0.096	0.507	0.063	0.021	1.000	0.111	0.102	0.084
type	0.206	0.183	0.247	0.141	0.081	0.065	0.111	1.000	0.866	0.078
length	0.064	0.156	0.049	0.113	0.069	0.066	0.102	0.866	1.000	0.086
Voucher Type	0.410	0.165	0.327	0.281	0.005	0.010	0.084	0.078	0.086	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Date	FY	Products	dia	dia group	grade	type	length	Voucher Type	Quantity	Rate	Value
0	04-03-2017	FY 18	25MM TATA TISCON FE500D (S)	25 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	25.49	40000.00	1019600.00
1	04-03-2017	FY 18	08MM TATA TISCON FE500D (S)	08 MM	08 MM	500D	FULL LENGTH	12 METER	Sales	9.09	43200.00	392688.00
2	04-03-2017	FY 18	10MM TATA TISCON FE500D (S)	10 MM	10 MM	500D	FULL LENGTH	12 METER	Sales	3.94	41700.00	164298.00
3	04-03-2017	FY 18	12MM TATA TISCON FE500D (S)	12 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	1.93	41200.00	79516.00
4	04-03-2017	FY 18	16MM TATA TISCON FE500D (S)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	1.03	41200.00	42436.00
5	04-03-2017	FY 18	25MM TATA TISCON FE500D (S)	25 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	24.91	40000.00	996400.00
6	04-04-2017	FY 18	08MM TATA TISCON FE500D (S)	08 MM	08 MM	500D	FULL LENGTH	12 METER	Sales	6.70	39976.19	267840.47
7	04-04-2017	FY 18	12MM TATA TISCON FE500D (S)	12 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	15.24	37976.19	578757.14
8	04-05-2017	FY 18	16MM TATA TISCON FE500D (S)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	13.72	40000.00	548800.00
9	04-05-2017	FY 18	20MM TATA TISCON FE500D (S)	20 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales	12.77	40000.00	510800.00

	Date	FY	Products	dia	dia group	grade	type	length	Voucher Type	Quantity	Rate	Value
33035	3/24/2023	FY 23	25MM TATA TISCON FE550D (T)	25 MM	12 MM - 32 MM	550D	FULL LENGTH	12 METER	Sales A/c GST	8.87	60000.0	532200.0
33036	3/25/2023	FY 23	08MM TATA TISCON FE550D (T)	08 MM	08 MM	550D	FULL LENGTH	12 METER	Sales A/c GST	7.59	62000.0	470580.0
33037	3/25/2023	FY 23	10MM TATA TISCON FE500D (T)	10 MM	10 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	3.72	61000.0	226920.0
33038	3/25/2023	FY 23	12MM TATA TISCON FE500D (T)	12 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	8.66	60000.0	519600.0
33039	3/25/2023	FY 23	16MM TATA TISCON FE500D (T)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	4.57	60000.0	274200.0
33040	3/25/2023	FY 23	20MM TATA TISCON FE500D (T)	20 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	4.08	60000.0	244800.0
33041	3/30/2023	FY 23	08MM TATA TISCON FE550D (T)	08 MM	08 MM	550D	FULL LENGTH	12 METER	Credit Note	-1.07	61000.0	-65270.0
33042	3/30/2023	FY 23	10MM TATA TISCON FE550D (T)	10 MM	10 MM	550D	FULL LENGTH	12 METER	Credit Note	-1.50	60000.0	-90000.0
33043	3/30/2023	FY 23	12MM TATA TISCON FE550D (T)	12 MM	12 MM - 32 MM	550D	FULL LENGTH	12 METER	Credit Note	-20.04	59000.0	-1182360.0
33044	3/30/2023	FY 23	20MM TATA TISCON FE500D (T)	20 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Credit Note	-4.60	59000.0	-271400.0

Most frequently occurring

	Date	FY	Products	dia	dia group	grade	type	length	Voucher Type	Quantity	Rate	Value	# duplicates
43	5/30/2018	FY 19	CUSTOMISED 08MM TATA TISCON FE500D (S)	08 MM	08 MM	500D	CAB	CUSTOMISED	Sales A/c GST	1.00	52400.0	52400.0	3
52	7/30/2019	FY 20	CUSTOMISED 12MM TATA TISCON FE500D (S)	12 MM	12 MM - 32 MM	500D	CAB	CUSTOMISED	Sales A/c GST	0.33	44200.0	14586.0	3
0	01-06-2022	FY 22	TISCON TMT COIL IS:1786 FE500 D 12 mm(T)	12 MM	12 MM - 32 MM	500D	COIL	0 METER	Sales A/c GST	1.99	57000.0	113430.0	2
1	01-09-2020	FY 20	10MM TATA TISCON FE500D (S)	10 MM	10 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	1.03	39500.0	40685.0	2
2	01-09-2020	FY 20	16MM TATA TISCON FE500D (S)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	2.03	40200.0	81606.0	2
3	02-10-2022	FY 22	16MM TATA TISCON FE500D (T)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	2.03	61250.0	124337.5	2
4	02-12-2019	FY 19	16MM TATA TISCON FE500D (S)	16 MM	12 MM - 32 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	3.10	43000.0	133300.0	2
5	02-12-2020	FY 20	10MM TATA TISCON FE500D (S)	10 MM	10 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	1.95	44000.0	85800.0	2
6	04-07-2018	FY 19	08MM TATA TISCON FE500D (S)	08 MM	08 MM	500D	FULL LENGTH	12 METER	Sales A/c GST	6.47	50000.0	323500.0	2
7	05-03-2022	FY 23	08MM TATA TISCON FE550D (T)	08 MM	08 MM	550D	FULL LENGTH	12 METER	Sales A/c GST	1.97	76000.0	149720.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Close Punctuation

Open Punctuation

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script